from django.db import models
from django.contrib.auth.models import User

class Label(models.Model):
    title = models.CharField(max_length=50)

class Neighborhood(models.Model):
    name = models.CharField(max_length=50)
    labels = models.ManyToManyField(Label)

class Ambassador(User):
    neighborhood = models.ForeignKey(Neighborhood)

class City(models.Model):
    name = models.CharField(max_length=100)

class Province(models.Model):
    name = models.CharField(max_length=100)

class Guide(models.Model):
    name = models.CharField(max_length=50)
    description = models.TextField()
    residence = models.ForeignKey(City)
    province = models.ForeignKey(Province)
    member_since = models.DateField()

class Rating(models.Model):
    user = models.ForeignKey(User)
    guide = models.ForeignKey(Guide)
    value = models.IntegerField()
